DB Engineer
/CMD=1
Tracking text is used to annotate the Relationship shape.
10 = Tracking Text
DB Engineer /CMD=1003
guard(pntx(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
guard(pnty(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
0 = IDEF1X; 2 = Relational
Overrides the relationship notation specifed by the IDEF1X or Relational notations.
Set to hide all relationships on the page
Set to hide relationship text.
Set to hide PK, FK, and Index annotations.
Set to hide the PK section of Entities.
Set to hide the Datatype section for Entities.
Set to hide the vertical lines seperating the Annotation and Datatype sections for Entities.
Set to hide the horizontal line seperating the Primary Key section from the other columns within Entities.
Use the Relationship connector to define a foreign key between two tables.
Relationship (Foreign Key)
Unique identifier used by the add-on.
Set to indicate the relationship is an 'Identifying Relationship'.
25=exactly one, 28=one or more, 29=zero one or more, 30=zero or one
Set to indicate the relationship is optional.
Set to override Database | Document | Options locally for this relationship shape.
Set to allow free-form editing (manual edits are not maintained in the model.)
This formula conditionally sets the DBNotation setting.
Calculates a reference point for Relationship text.
This formula conditionally sets the CrowsFoot notation flag.
Shape's version.
reference to associated text shape
Locate referencial integrity text here.
Locate cardinality text here.
Relational Notation
IDEF1X Notation
Crow's Foot Notation
Database Model master stores embedded model information.
Root Entry
VisDBEngrData
VisDBEngrDocData
VisDBEngrObjMapData
&DocTitleLong
Arial
&PageDesc
&Date &Time
AriaVisDBEngrSecondaryObjMapData
VisDBEngrModelEngData
IMWDD.Document
Styles
ORMInfo
UGRPInfo
MAPInfo
TSTAMPInfo
numeric
PurchaseDate
is of
datetime
DateAcquired
is identified by
TransactionID
identifies
AcquisitionPrice
TRANSACTION
WorkID
CustomerID
AskingPrice
SalesPrice
AreaCode
CUSTOMER
Email
char
PhoneNumber
Country
ZipPostalCOde
State
City
Street
Name
CUSTOMERName
ARTIST
DeceasedDate
Birthdate
Nationality
ARTISTName
ArtistID
WORK
Description
varchar
Copy
Title
is partly identified by
partly identifies
CUSTOMER_ARTIST_INT
1DWj
*.ATgz
Microsoft SQL Server (4.2+)
DOT\MSSMLBIZ
&PageNo
Date of last Merge
Date of last Validation
Date of last Mapping
NationalityValues
([Nationality]='US' OR [Nationality]='Spanish' OR [Nationality]='Russian' OR [Nationality]='Mexican' OR [Nationality]='Germen' OR [Nationality]='French' OR [Nationality]='English' OR [Nationality]='Canadian')
ValidBirthYear
([Birthdate] like '[1-2] [0-9] [0-9] [0-9]')
ValidDeathYear
([DeceasedDate] like '[1-2] [0-9] [0-9] [0-9]')
PRIMARY
SalesPriceRange
([SalesPrice]>(1000) AND [SalesPrice]<=(200000))
TransactionWorkFK
hasTransactionWorkFK
TransactionPK
ValidTransDate
([PurchaseDate]>=[DateAcquired])
TransactionCustomerFK
hasTransactionCustomerFK
CustomerPK
cPRIMARY
EmailAK1
Customer_Artist_Int_CustomerFK
hasCustomer_Artist_Int_CustomerFK
CustomerArtistPK
Customer_Artist_Int_ArtistFK
hasCustomer_Artist_Int_ArtistFK
ArtistPK
ArtistAK1
BirthValuesCheck
([Birthdate]<[DeceasedDate])
ArtistFK
hasArtistFK
WorkPK
WorkAK1
wusqomki><XVTRPNLJHF'%#!
DSN=Art;Description=Art;Trusted_Connection=Yes;APP=Microsoft
Office Visio
2007;WSID=DOT;DATABASE=Art;
fn_diagramobjects
CREATE FUNCTION dbo.fn_diagramobjects()
RETURNS int
WITH EXECUTE AS N'dbo'
BEGIN
declare @id_upgraddiagrams
declare @id_sysdiagrams
declare @id_helpdiagrams
declare @id_helpdiagramdefinition
declare @id_creatediagram
declare @id_renamediagram
declare @id_alterdiagram
int
declare @id_dropdiagram
declare @InstalledObjects
select @InstalledObjects = 0
select
@id_upgraddiagrams = object_id(N'dbo.sp_upgraddiagrams'),
@id_sysdiagrams = object_id(N'dbo.sysdiagrams'),
@id_helpdiagrams = object_id(N'dbo.sp_helpdiagrams'),
@id_helpdiagramdefinition = object_id(N'dbo.sp_helpdiagramdefinition'),
@id_creatediagram = object_id(N'dbo.sp_creatediagram'),
@id_renamediagram = object_id(N'dbo.sp_renamediagram'),
@id_alterdiagram = object_id(N'dbo.sp_alterdiagram'),
@id_dropdiagram = object_id(N'dbo.sp_dropdiagram')
if @id_upgraddiagrams is not null
select @InstalledObjects = @InstalledObjects + 1
if @id_sysdiagrams is not null
select @InstalledObjects = @InstalledObjects + 2
if @id_helpdiagrams is not null
select @InstalledObjects = @InstalledObjects + 4
if @id_helpdiagramdefinition is not null
select @InstalledObjects = @InstalledObjects + 8
if @id_creatediagram is not null
select @InstalledObjects = @InstalledObjects + 16
if @id_renamediagram is not null
select @InstalledObjects = @InstalledObjects + 32
if @id_alterdiagram is not null
select @InstalledObjects = @InstalledObjects + 64
if @id_dropdiagram is not null
select @InstalledObjects = @InstalledObjects + 128
return @InstalledObjects
sp_alterdiagram
CREATE PROCEDURE dbo.sp_alterdiagram
@diagramname
sysname,
@owner_id
= null,
@version
int,
@definition
varbinary(max)
WITH EXECUTE AS 'dbo'
set nocount on
declare @theId
declare @retval
declare @IsDbo
declare @UIDFound
declare @DiagId
declare @ShouldChangeUID
if(@diagramname is null)
begin
RAISERROR ('Invalid ARG', 16, 1)
return -1
execute as caller;
select @theId = DATABASE_PRINCIPAL_ID();
select @IsDbo = IS_MEMBER(N'db_owner');
if(@owner_id is null)
select @owner_id = @theId;
revert;
select @ShouldChangeUID = 0
select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname
if(@DiagId IS NULL or (@IsDbo = 0 and @theId <> @UIDFound))
RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1);
return -3
if(@IsDbo <> 0)
if(@UIDFound is null or USER_NAME(@UIDFound) is null) -- invalid principal_id
select @ShouldChangeUID = 1 ;
-- update dds data
update dbo.sysdiagrams set definition = @definition where diagram_id = @DiagId ;
-- change owner
if(@ShouldChangeUID = 1)
update dbo.sysdiagrams set principal_id = @theId where diagram_id = @DiagId ;
-- update dds version
if(@version is not null)
update dbo.sysdiagrams set version = @version where diagram_id = @DiagId ;
return 0
sp_creatediagram
TE PROCEDURE dbo.sp_creatediagram
declare @theId int
declare @retval int
are @IsDbo
declare @userName sysname
if(@version is null or @diagramname is null)
RAISERROR (N'E_INVALIDARG', 16, 1);
if @owner_id is null
else
if @theId <> @owner_id
if @IsDbo = 0
select @theId = @owner_id
-- next 2 line only for test, will be removed after define name unique
if EXISTS(select diagram_id from dbo.sysdiagrams where principal_id = @theId and name = @diagramname)
RAISERROR ('The name is already used.', 16, 1);
return -2
insert into dbo.sysdiagrams(name, principal_id , version, definition)
VALUES(@diagramname, @theId, @version, @definition) ;
select @retval = @@IDENTITY
return @retval
sp_dropdiagram
CREATE PROCEDURE dbo.sp_dropdiagram
= null
RAISERROR ('Invalid value', 16, 1);
EXECUTE AS CALLER;
REVERT;
if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId))
RAISERROR ('Diagram does not exist or you do not have permission.', 16, 1)
delete from dbo.sysdiagrams where diagram_id = @DiagId;
return 0;
sp_helpdiagramdefinition
CREATE PROCEDURE dbo.sp_helpdiagramdefinition
select @DiagId = diagram_id, @UIDFound = principal_id from dbo.sysdiagrams where principal_id = @owner_id and name = @diagramname;
if(@DiagId IS NULL or (@IsDbo = 0 and @UIDFound <> @theId ))
select version, definition FROM dbo.sysdiagrams where diagram_id = @DiagId ;
sp_helpdiagrams
CREATE PROCEDURE dbo.sp_helpdiagrams
@diagramname sysname = NULL,
@owner_id int = NULL
DECLARE @user sysname
DECLARE @dboLogin bit
SET @user = USER_NAME();
SET @dboLogin = CONVERT(bit,IS_MEMBER('db_owner'));
SELECT
[Database] = DB_NAME(),
[Name] = name,
[ID] = diagram_id,
[Owner] = USER_NAME(principal_id),
[OwnerID] = principal_id
FROM
sysdiagrams
WHERE
(@dboLogin = 1 OR USER_NAME(principal_id) = @user) AND
(@diagramname IS NULL OR name = @diagramname) AND
(@owner_id IS NULL OR principal_id = @owner_id)
ORDER BY
sp_renamediagram
CREATE PROCEDURE dbo.sp_renamediagram
@new_diagramname
sysname
declare @DiagIdTarg
declare @u_name
if((@diagramname is null) or (@new_diagramname is null))
select @u_name = USER_NAME(@owner_id)
-- if((@u_name is not null) and (@new_diagramname = @diagramname))
-- nothing will change
if(@u_name is null)
select @DiagIdTarg = diagram_id from dbo.sysdiagrams where principal_id = @theId and name = @new_diagramname
select @DiagIdTarg = diagram_id from dbo.sysdiagrams where principal_id = @owner_id and name = @new_diagramname
if((@DiagIdTarg is not null) and @DiagId <> @DiagIdTarg)
update dbo.sysdiagrams set [name] = @new_diagramname, principal_id = @theId where diagram_id = @DiagId
update dbo.sysdiagrams set [name] = @new_diagramname where diagram_id = @DiagId
sp_upgraddiagrams
CREATE PROCEDURE dbo.sp_upgraddiagrams
IF OBJECT_ID(N'dbo.sysdiagrams') IS NOT NULL
CREATE TABLE dbo.sysdiagrams
name sysname NOT NULL,
principal_id int NOT NULL,
-- we may change it to varbinary(85)
diagram_id int PRIMARY KEY IDENTITY,
version int,
definition varbinary(max)
CONSTRAINT UK_principal_name UNIQUE
principal_id,
name
/* Add this if we need to have some form of extended properties for diagrams */
IF OBJECT_ID(N'dbo.sysdiagram_properties') IS NULL
CREATE TABLE dbo.sysdiagram_properties
diagram_id int,
name sysname,
value varbinary(max) NOT NULL
IF OBJECT_ID(N'dbo.dtproperties') IS NOT NULL
insert into dbo.sysdiagrams
[name],
[principal_id],
[version],
[definition]
convert(sysname, dgnm.[uvalue]),
DATABASE_PRINCIPAL_ID(N'dbo'),
-- will change to the sid of sa
-- zero for old format, dgdef.[version],
dgdef.[lvalue]
from dbo.[dtproperties] dgnm
inner join dbo.[dtproperties] dggd on dggd.[property] = 'DtgSchemaGUID' and dggd.[objectid] = dgnm.[objectid]
inner join dbo.[dtproperties] dgdef on dgdef.[property] = 'DtgSchemaDATA' and dgdef.[objectid] = dgnm.[objectid]
where dgnm.[property] = 'DtgSchemaNAME' and dggd.[uvalue] like N'_EA3E6268-D998-11CE-9454-00AA00A3F36E_'
return 2;
return 1;
SourceDocs
Folders
SummaryInformation
DBSnapshot
VisDBEngrSecondaryObjMapData
Dictionary
Relational,Database,Entity,Relationship,IDEF1X
0 = IDEF1X, 2 = Relational
Set to hide the PK seperator lines in the Entities on this page.
Set to hide the Tabstop lines in the Entities on this page.
Drag onto the page to add a table.
elationship diagram.
Entity
Identifies the shape's version to the add-on.
Set for dependent tables.
Set to allow free-from edits (manual edits are not maintained in the model)
Set if this shape's Database | Document | Options have have local overrides.
Conditionally sets the DBNotation setting.
Use to add a table to your Entity Relationship diagram.
width of this shape's text
height of this shape's text
Subshape id within the Entity group shape.
Subshape ID within the Entity group shape.
specifies the number of columns in the tables primary key
Set to hide the horizontal line seperating the PK columns from the rest.
Set to hide the 1st vertical tab line.
Set to hide the 2nd vertical tab line.
Indicates the number of lines in the text.
Indicates the height of one text line.
two,key,Relational,Database,Entity,Relationship,IDEF1X,foreign,tables
Drag onto the page to define a foreign key between two tables.
Use to define a foreign key between two tables in your Entity Relationship diagram.
Add text here.
c:\program files\microsoft office\office12\1033\ENTITY_U.VSS
c:\program files\microsoft office\office12\1033\OBJREL_U.VSS
Set to hide category discriminators.
Set to hide PK, FK, and Index annotations within Entities.
Set to Hide Primary Key section within Entities.
Set to hide Datatypes section within Entities.
Set to hide the vertical lines that seperate the Annotation and Datatype sections within Entities.
Set to hide the horizontal line that seperates the PK section from the other columns of an Entity.
{72B267C6-BCF5-4F2A-A671-F6899E06674E}
Database Properties...
Show Related Tables
{E7690AF3-DAFE-4D09-AD00-73074D7F6199}
{CD5C44A3-9F14-400D-94AD-2040992A4018}
{D8C177E7-7360-4777-9DD8-5243FD07460B}
{3772C266-7F5D-4ECC-92A3-C8880FC22677}
{14EEF89F-5806-4D0D-B6D8-EC881D64B2F9}
{0944B2F0-31C0-48EB-8C19-82AC6CCF75F7}
{21B22F17-1830-48A7-A007-105B7006A364}
{C4C337BC-28E2-446A-9E16-1E6A3CAE1F1A}
{D7F9E2B4-0B6F-4B87-99E5-74B4090AA527}
Arial Unicode MS
Symbol
Wingdings
SimSun
PMingLiU
MS PGothic
Dotum
Sylfaen
Estrangelo Edessa
Vrinda
Shruti
Mangal
Tunga
Sendnya
Raavi
Dhenu
Latha
Gautami
Cordia New
MS Farsi
Gulim
Times New Roman
Guide
TheDoc
Page-1
Gesture Format
Row_1
DBNotation
Row_2
DBCrowsFoot
Row_3
DBHideDiscriminator
Row_4
DBHideAnnotations
Database Model
DBHidePKRow
Visio Extended Data
DBHideTypes
DBHideVerticalLines
DBDependent
DBHideHorizontalLine
msvNoAutoConnect
msvNoApplyDataGraphicAfterLink
Connector
Tracking Text
DBShapeType
DBEventTrigger
OldPinX
OldPinY
ManualEdits
Hide
SetPinX
SetPinY
DBShapeVersion
RefSheetID
RefControl
Dynamic Connector
DBHideRelationships
DBHideRelationshipText
RefShapeGuid
Identifying
DBCardinality
CrowsFoot
Optional
Override
OverrideDBNotation
EndAngle
OverrideCrowsFoot
BeginAngle
RITextRefGuid
CardTextRefGuid
visDescription
visVersion
Width
Height
SubShapeID
PKCount
DBHidePKSeperatorLine
DBHideTabLine1
DBHideTabLine2
LineCount
LineHeight
Relationship